Essbase Server

To connect to Essbase cubes select button:

·             user defined connections

 

Dialog will appear.

 

 

In Server box select Essbase as server type.

 

 

Set:

 

·         Analysis name – this one will be used on tab of selected analysis

·         Connection name – used to differ connections

·         Server –name

http://serverbane.domain.local:9000/aps/XMLA

·         Database – enter database name

·         Cube – enter cube name

·         Connection string box – enter other information like:

Provider=Essbase; Data Source=olap-7

 

If your connection requires user name and password then uncheck integrated security checkbox and enter appropriate user name and password.